BEGIN TRANSACTION
ALTER TABLE dbo.data_SalesInfo ADD
	LoginID smallint NULL,
	LoginHost varchar(50) NOT NULL CONSTRAINT DF_data_SalesInfo_LoginHost DEFAULT HOST_NAME(),
	EntryDateTime datetime NOT NULL CONSTRAINT DF_data_SalesInfo_EntryDateTime DEFAULT GETDATE(),
	ModifyID smallint NULL,
	ModifyHost varchar(50) NOT NULL CONSTRAINT DF_data_SalesInfo_ModifyHost DEFAULT HOST_NAME(),
	ModifyDateTime datetime NOT NULL CONSTRAINT DF_data_SalesInfo_ModifyDateTime DEFAULT GETDATE()
GO
COMMIT

BEGIN TRANSACTION
ALTER TABLE dbo.Voucher ADD
	LoginID smallint NULL,
	LoginHost varchar(50) NOT NULL CONSTRAINT DF_Voucher_LoginHost DEFAULT (host_name()),
	EntryDateTime datetime NOT NULL CONSTRAINT DF_Voucher_EntryDateTime DEFAULT (getdate()),
	ModifyID smallint NULL,
	ModifyHost varchar(50) NOT NULL CONSTRAINT DF_Voucher_ModifyHost DEFAULT (host_name()),
	ModifyDateTime datetime NOT NULL CONSTRAINT DF_Voucher_ModifyDateTime DEFAULT (getdate())
GO
COMMIT

BEGIN TRANSACTION
UPDATE dbo.data_SalesInfo SET
	LoginID =1,ModifyID =1 
GO
COMMIT

BEGIN TRANSACTION
UPDATE dbo.Voucher SET
	LoginID=1, ModifyID=1 
GO
COMMIT